package com.china08.yxyapi.repository.mg;

import org.springframework.data.domain.Page;
import org.springframework.data.domain.Pageable;
import org.springframework.data.mongodb.repository.MongoRepository;

import com.china08.yxyapi.entity.mg.statistics.SchoolUploadResourceReport;

public interface SchoolUploadResourceReportRepository extends MongoRepository<SchoolUploadResourceReport, String> {
	 /**
	  * 通过    学校上传资源统计id 查询相关记录
	  * @param schoolId
	  * @return
	  */
	 SchoolUploadResourceReport findById(String schoolId);

	 /**
	  * 通过市代码、学校名称（模糊查询）查出相关记录
	  * @param districtCode
	  * @param schoolName
	  * @param pageable
	  * @return
	  */
    Page<SchoolUploadResourceReport> findByAreaIdCityAndSchoolNickLike(String districtCode, String schoolName,
            Pageable pageable);

   
    /**
     * 通过市代码、区域名称、学校名称（模糊查询）查出相关记录
     * @param districtCode
     * @param areaName
     * @param schoolName
     * @param pageable
     * @return
     */
    Page<SchoolUploadResourceReport> findByAreaIdCityAndAreaNameDistrictAndSchoolNickLike(String districtCode,
            String areaName, String schoolName, Pageable pageable);
    /**
     * 通过市代码、区域名称、学校名称（模糊名称）并且按资源上传数量进行倒序排序
     * @param districtCode
     * @param areaName
     * @param schoolName
     * @param pageable
     * @return
     */
    Page<SchoolUploadResourceReport> findByAreaIdCityAndAreaNameDistrictAndSchoolNickLikeOrderByResCountDesc(
            String districtCode, String areaName, String schoolName, Pageable pageable);
    /**
     * 通过市代码、区域名称、学校名称（模糊名称）并且按资源上传数量进行顺序排序
     * @param districtCode
     * @param areaName
     * @param schoolName
     * @param pageable
     * @return
     */
    Page<SchoolUploadResourceReport> findByAreaIdCityAndAreaNameDistrictAndSchoolNickLikeOrderByResCountAsc(
            String districtCode, String areaName, String schoolName, Pageable pageable);
    /**
     * 通过市代码、区域名称、学校名称（模糊查询）并且按共享资源数量进行倒序排序
     * @param districtCode
     * @param areaName
     * @param schoolName
     * @param pageable
     * @return
     */
    Page<SchoolUploadResourceReport> findByAreaIdCityAndAreaNameDistrictAndSchoolNickLikeOrderByShareResCountDesc(
            String districtCode, String areaName, String schoolName, Pageable pageable);
    /**
     * 通过市代码、区域名称、学校名称（模糊查询）并且按共享资源数量进行顺序排序
     * @param districtCode
     * @param areaName
     * @param schoolName
     * @param pageable
     * @return
     */
    Page<SchoolUploadResourceReport> findByAreaIdCityAndAreaNameDistrictAndSchoolNickLikeOrderByShareResCountAsc(
            String districtCode, String areaName, String schoolName, Pageable pageable);
    /**
     * 通过市代码、学校名称（模糊查询）并且按资源上传数量进行倒序排序
     * @param districtCode
     * @param schoolName
     * @param pageable
     * @return
     */
    Page<SchoolUploadResourceReport> findByAreaIdCityAndSchoolNickLikeOrderByResCountDesc(String districtCode,
            String schoolName, Pageable pageable);
    /**
     * 通过市代码、学校名称（模糊查询）并且按资源上传数量进行顺序排序
     * @param districtCode
     * @param schoolName
     * @param pageable
     * @return
     */
    Page<SchoolUploadResourceReport> findByAreaIdCityAndSchoolNickLikeOrderByResCountAsc(String districtCode,
            String schoolName, Pageable pageable);
    /**
     * 通过市代码、学校名称（模糊查询）并且按资源共享数量进行倒序排序
     * @param districtCode
     * @param schoolName
     * @param pageable
     * @return
     */
    Page<SchoolUploadResourceReport> findByAreaIdCityAndSchoolNickLikeOrderByShareResCountDesc(String districtCode,
            String schoolName, Pageable pageable);
    /**
     * 通过市代码、学校名称（模糊查询）并且按资源共享数量进行顺序排序
     * @param districtCode
     * @param schoolName
     * @param pageable
     * @return
     */
    Page<SchoolUploadResourceReport> findByAreaIdCityAndSchoolNickLikeOrderByShareResCountAsc(String districtCode,
            String schoolName, Pageable pageable);
    /**
     * 通过市代码、区域名称查询相关记录
     * @param districtCode
     * @param areaName
     * @param pageable
     * @return
     */
	Page<SchoolUploadResourceReport> findByAreaIdCityAndAreaNameDistrict(String districtCode, String areaName, Pageable pageable);


    /**
     * 通过市代码并且按资源上传数量进行倒序排序
     * @param areaName
     * @param pageable
     * @return
     */
	Page<SchoolUploadResourceReport> findByAreaIdCityOrderByResCountDesc(String areaName, Pageable pageable);
    /**
     * 通过市代码并且按资源上传数量进行顺序排序
     * @param districtCode
     * @param pageable
     * @return
     */
	Page<SchoolUploadResourceReport> findByAreaIdCityOrderByResCountAsc(String districtCode, Pageable pageable);
    /**
     * 通过市代码并且按资源共享数量进行倒序排序
     * @param districtCode
     * @param pageable
     * @return
     */
	Page<SchoolUploadResourceReport> findByAreaIdCityOrderByShareResCountDesc(String districtCode, Pageable pageable);
    /**
     * 通过市代码并且按资源共享数量进行顺序排序
     * @param districtCode
     * @param pageable
     * @return
     */
	Page<SchoolUploadResourceReport> findByAreaIdCityOrderByShareResCountAsc(String districtCode, Pageable pageable);
    /**
     * 通过判断学段是否包含指定内容，并且根据市代码查询相关记录
     * @param phaseName
     * @param districtCode
     * @param pageable
     * @return
     */
	Page<SchoolUploadResourceReport> findByStageInAndAreaIdCity(String phaseName, String districtCode, Pageable pageable);

	/**
	 * 
	 * @param districtCode
	 * @param schoolName
	 * @param pageable
	 * @return
	 */
	Page<SchoolUploadResourceReport> findByAreaIdDistrictAndSchoolNickLike(String districtCode, String schoolName, Pageable pageable);

	

	Page<SchoolUploadResourceReport> findByAreaIdDistrictOrderByResCountDesc(String districtCode, Pageable pageable);

	Page<SchoolUploadResourceReport> findByAreaIdDistrictOrderByResCountAsc(String districtCode, Pageable pageable);

	Page<SchoolUploadResourceReport> findByAreaIdDistrictOrderByShareResCountDesc(String districtCode, Pageable pageable);

	Page<SchoolUploadResourceReport> findByAreaIdDistrictOrderByShareResCountAsc(String districtCode, Pageable pageable);

	Page<SchoolUploadResourceReport> findByAreaIdProvinceAndSchoolNickLike(String districtCode, String schoolName, Pageable pageable);

	Page<SchoolUploadResourceReport> findByAreaIdProvinceAndAreaNameCityAndSchoolNickLike(String districtCode,
			String cityName, String schoolName, Pageable pageable);

	Page<SchoolUploadResourceReport> findByAreaIdProvinceAndAreaNameCityAndAreaNameDistrictAndSchoolNickLike(
			String districtCode, String cityName, String areaName, String schoolName, Pageable pageable);

	Page<SchoolUploadResourceReport> findByAreaIdProvinceAndAreaNameCityAndAreaNameDistrictAndSchoolNickLikeOrderByResCountDesc(
			String districtCode, String cityName, String areaName, String schoolName, Pageable pageable);

	Page<SchoolUploadResourceReport> findByAreaIdProvinceAndAreaNameCityAndAreaNameDistrictAndSchoolNickLikeOrderByResCountAsc(
			String districtCode, String cityName, String areaName, String schoolName, Pageable pageable);

	Page<SchoolUploadResourceReport> findByAreaIdProvinceAndAreaNameCityAndAreaNameDistrictAndSchoolNickLikeOrderByShareResCountDesc(
			String districtCode, String cityName, String areaName, String schoolName, Pageable pageable);

	Page<SchoolUploadResourceReport> findByAreaIdProvinceAndAreaNameCityAndAreaNameDistrictAndSchoolNickLikeOrderByShareResCountAsc(
			String districtCode, String cityName, String areaName, String schoolName, Pageable pageable);

	Page<SchoolUploadResourceReport> findByAreaIdProvinceAndAreaNameCityAndSchoolNickLikeOrderByResCountDesc(
			String districtCode, String cityName, String schoolName, Pageable pageable);

	Page<SchoolUploadResourceReport> findByAreaIdProvinceAndAreaNameCityAndSchoolNickLikeOrderByResCountAsc(
			String districtCode, String cityName, String schoolName, Pageable pageable);

	Page<SchoolUploadResourceReport> findByAreaIdProvinceAndAreaNameCityAndSchoolNickLikeOrderByShareResCountDesc(
			String districtCode, String cityName, String schoolName, Pageable pageable);

	Page<SchoolUploadResourceReport> findByAreaIdProvinceAndAreaNameCityAndSchoolNickLikeOrderByShareResCountAsc(
			String districtCode, String cityName, String schoolName, Pageable pageable);

	Page<SchoolUploadResourceReport> findByAreaIdProvinceAndSchoolNickLikeOrderByResCountDesc(String districtCode,
			String schoolName, Pageable pageable);

	Page<SchoolUploadResourceReport> findByAreaIdProvinceAndSchoolNickLikeOrderByResCountAsc(String districtCode,
			String schoolName, Pageable pageable);

	Page<SchoolUploadResourceReport> findByAreaIdProvinceAndSchoolNickLikeOrderByShareResCountDesc(String districtCode,
			String schoolName, Pageable pageable);

	Page<SchoolUploadResourceReport> findByAreaIdProvinceAndSchoolNickLikeOrderByShareResCountAsc(String districtCode,
			String schoolName, Pageable pageable);

	Page<SchoolUploadResourceReport> findByAreaIdProvinceAndAreaNameCity(String districtCode, String cityName, Pageable pageable);

	Page<SchoolUploadResourceReport> findByAreaIdProvinceAndAreaNameCityAndAreaNameDistrict(String districtCode,
			String cityName, String areaName, Pageable pageable);

	Page<SchoolUploadResourceReport> findByAreaIdProvinceAndAreaNameCityAndAreaNameDistrictOrderByResCountDesc(
			String districtCode, String cityName, String areaName, Pageable pageable);

	Page<SchoolUploadResourceReport> findByAreaIdProvinceAndAreaNameCityAndAreaNameDistrictOrderByResCountAsc(
			String districtCode, String cityName, String areaName, Pageable pageable);

	Page<SchoolUploadResourceReport> findByAreaIdProvinceAndAreaNameCityAndAreaNameDistrictOrderByShareResCountDesc(
			String districtCode, String cityName, String areaName, Pageable pageable);

	Page<SchoolUploadResourceReport> findByAreaIdProvinceAndAreaNameCityAndAreaNameDistrictOrderByShareResCountAsc(
			String districtCode, String cityName, String areaName, Pageable pageable);

	Page<SchoolUploadResourceReport> findByAreaIdProvinceAndAreaNameCityOrderByResCountDesc(String districtCode, String cityName, Pageable pageable);

	Page<SchoolUploadResourceReport> findByAreaIdProvinceAndAreaNameCityOrderByResCountAsc(String districtCode,
			String cityName, Pageable pageable);

	Page<SchoolUploadResourceReport> findByAreaIdProvinceAndAreaNameCityOrderByShareResCountDesc(String districtCode,
			String cityName, Pageable pageable);

	Page<SchoolUploadResourceReport> findByAreaIdProvinceAndAreaNameCityOrderByShareResCountAsc(String districtCode,
			String cityName, Pageable pageable);

	Page<SchoolUploadResourceReport> findByAreaIdProvinceOrderByResCountDesc(String districtCode, Pageable pageable);

	Page<SchoolUploadResourceReport> findByAreaIdProvinceOrderByResCountAsc(String districtCode, Pageable pageable);

	Page<SchoolUploadResourceReport> findByAreaIdProvinceOrderByShareResCountDesc(String districtCode, Pageable pageable);

	Page<SchoolUploadResourceReport> findByAreaIdProvinceOrderByShareResCountAsc(String districtCode, Pageable pageable);


	Page<SchoolUploadResourceReport> findByAreaIdDistrictAndStageInAndSchoolNickLike(String districtCode, String phaseName,
			String schoolName, Pageable pageable);

	Page<SchoolUploadResourceReport> findByAreaIdDistrictAndStageInAndSchoolNickLikeOrderByResCountDesc(
			String districtCode, String phaseName, String schoolName, Pageable pageable);

	Page<SchoolUploadResourceReport> findByAreaIdDistrictAndStageInAndSchoolNickLikeOrderByResCountAsc(
			String districtCode, String phaseName, String schoolName, Pageable pageable);

	Page<SchoolUploadResourceReport> findByAreaIdDistrictAndStageInAndSchoolNickLikeOrderByShareResCountDesc(
			String districtCode, String phaseName, String schoolName, Pageable pageable);

	Page<SchoolUploadResourceReport> findByAreaIdDistrictAndStageInAndSchoolNickLikeOrderByShareResCountAsc(
			String districtCode, String phaseName, String schoolName, Pageable pageable);

	Page<SchoolUploadResourceReport> findByAreaIdDistrictAndSchoolNickLikeOrderByResCountDesc(String districtCode,
			String schoolName, Pageable pageable);

	Page<SchoolUploadResourceReport> findByAreaIdDistrictAndSchoolNickLikeOrderByResCountAsc(String districtCode,
			String schoolName, Pageable pageable);

	Page<SchoolUploadResourceReport> findByAreaIdDistrictAndSchoolNickLikeOrderByShareResCountDesc(String districtCode,
			String schoolName, Pageable pageable);

	Page<SchoolUploadResourceReport> findByAreaIdDistrictAndSchoolNickLikeOrderByShareResCountAsc(String districtCode,
			String schoolName, Pageable pageable);

	Page<SchoolUploadResourceReport> findByAreaIdDistrictAndStageIn(String districtCode, String phaseName,
			Pageable pageable);

	Page<SchoolUploadResourceReport> findByAreaIdDistrictAndStageInOrderByResCountDesc(String districtCode,
			String phaseName, Pageable pageable);

	Page<SchoolUploadResourceReport> findByAreaIdDistrictAndStageInOrderByResCountAsc(String districtCode,
			String phaseName, Pageable pageable);

	Page<SchoolUploadResourceReport> findByAreaIdDistrictAndStageInOrderByShareResCountDesc(String districtCode,
			String phaseName, Pageable pageable);

	Page<SchoolUploadResourceReport> findByAreaIdDistrictAndStageInOrderByShareResCountAsc(String districtCode,
			String phaseName, Pageable pageable);

	Page<SchoolUploadResourceReport> findByAreaIdCityAndAreaNameDistrictAndStageInAndSchoolNickLike(String districtCode,
			String areaName, String phaseName, String schoolName, Pageable pageable);

	Page<SchoolUploadResourceReport> findByAreaIdCityAndAreaNameDistrictAndStageInAndSchoolNickLikeOrderByResCountDesc(
			String districtCode, String areaName, String phaseName, String schoolName, Pageable pageable);

	Page<SchoolUploadResourceReport> findByAreaIdCityAndAreaNameDistrictAndStageInAndSchoolNickLikeOrderByResCountAsc(
			String districtCode, String areaName, String phaseName, String schoolName, Pageable pageable);

	Page<SchoolUploadResourceReport> findByAreaIdCityAndAreaNameDistrictAndStageInAndSchoolNickLikeOrderByShareResCountDesc(
			String districtCode, String areaName, String phaseName, String schoolName, Pageable pageable);

	Page<SchoolUploadResourceReport> findByAreaIdCityAndAreaNameDistrictAndStageInAndSchoolNickLikeOrderByShareResCountAsc(
			String districtCode, String areaName, String phaseName, String schoolName, Pageable pageable);

	Page<SchoolUploadResourceReport> findByAreaIdCityAndAreaNameDistrictAndStageIn(String districtCode, String areaName,
			String phaseName, Pageable pageable);

	Page<SchoolUploadResourceReport> findByAreaIdCityAndAreaNameDistrictAndStageInOrderByResCountDesc(
			String districtCode, String phaseName, String areaName, Pageable pageable);

	Page<SchoolUploadResourceReport> findByAreaIdCityAndAreaNameDistrictAndStageInOrderByResCountAsc(
			String districtCode, String areaName, String phaseName, Pageable pageable);

	Page<SchoolUploadResourceReport> findByAreaIdCityAndAreaNameDistrictAndStageInOrderByShareResCountDesc(
			String districtCode, String areaName, String phaseName, Pageable pageable);

	Page<SchoolUploadResourceReport> findByAreaIdCityAndAreaNameDistrictAndStageInOrderByShareResCountAsc(
			String districtCode, String areaName, String phaseName, Pageable pageable);

	Page<SchoolUploadResourceReport> findByAreaIdCityAndStageInOrderByResCountDesc(String districtCode,
			String phaseName, Pageable pageable);

	Page<SchoolUploadResourceReport> findByAreaIdCityAndStageInOrderByResCountAsc(String districtCode, String phaseName,
			Pageable pageable);

	Page<SchoolUploadResourceReport> findByAreaIdCityAndStageInOrderByShareResCountDesc(String districtCode,
			String phaseName, Pageable pageable);

	Page<SchoolUploadResourceReport> findByAreaIdCityAndStageInOrderByShareResCountAsc(String districtCode,
			String phaseName, Pageable pageable);

	Page<SchoolUploadResourceReport> findByAreaIdProvinceAndAreaNameCityAndAreaNameDistrictAndStageInAndSchoolNickLike(
			String districtCode, String cityName, String areaName, String phaseName, String schoolName,
			Pageable pageable);

	Page<SchoolUploadResourceReport> findByAreaIdProvinceAndAreaNameCityAndAreaNameDistrictAndStageInAndSchoolNickLikeOrderByResCountDesc(
			String districtCode, String cityName, String areaName, String phaseName, String schoolName,
			Pageable pageable);

	Page<SchoolUploadResourceReport> findByAreaIdProvinceAndAreaNameCityAndAreaNameDistrictAndStageInAndSchoolNickLikeOrderByResCountAsc(
			String districtCode, String cityName, String areaName, String phaseName, String schoolName,
			Pageable pageable);

	Page<SchoolUploadResourceReport> findByAreaIdProvinceAndAreaNameCityAndAreaNameDistrictAndStageInAndSchoolNickLikeOrderByShareResCountDesc(
			String districtCode, String cityName, String areaName, String phaseName, String schoolName,
			Pageable pageable);

	Page<SchoolUploadResourceReport> findByAreaIdProvinceAndAreaNameCityAndAreaNameDistrictAndStageInAndSchoolNickLikeOrderByShareResCountAsc(
			String districtCode, String cityName, String areaName, String phaseName, String schoolName,
			Pageable pageable);

	Page<SchoolUploadResourceReport> findByAreaIdProvinceAndAreaNameCityAndAreaNameDistrictAndStageIn(
			String districtCode, String cityName, String areaName, String phaseName, Pageable pageable);

	Page<SchoolUploadResourceReport> findByAreaIdProvinceAndAreaNameCityAndAreaNameDistrictAndStageInOrderByResCountDesc(
			String districtCode, String cityName, String areaName, String phaseName, Pageable pageable);

	Page<SchoolUploadResourceReport> findByAreaIdProvinceAndAreaNameCityAndAreaNameDistrictAndStageInOrderByResCountAsc(
			String districtCode, String cityName, String areaName, String phaseName, Pageable pageable);

	Page<SchoolUploadResourceReport> findByAreaIdProvinceAndAreaNameCityAndAreaNameDistrictAndStageInOrderByShareResCountDesc(
			String districtCode, String cityName, String areaName, String phaseName, Pageable pageable);

	Page<SchoolUploadResourceReport> findByAreaIdProvinceAndAreaNameCityAndAreaNameDistrictAndStageInOrderByShareResCountAsc(
			String districtCode, String cityName, String areaName, String phaseName, Pageable pageable);

	Page<SchoolUploadResourceReport> findByAreaIdCityAndAreaNameDistrictOrderByResCountDesc(String districtCode,
			String areaName, Pageable pageable);

	Page<SchoolUploadResourceReport> findByAreaIdCityAndAreaNameDistrictOrderByResCountAsc(String districtCode,
			String areaName, Pageable pageable);

	Page<SchoolUploadResourceReport> findByAreaIdCityAndAreaNameDistrictOrderByShareResCountDesc(String districtCode,
			String areaName, Pageable pageable);

	Page<SchoolUploadResourceReport> findByAreaIdCityAndAreaNameDistrictOrderByShareResCountAsc(String districtCode,
			String areaName, Pageable pageable);

	Page<SchoolUploadResourceReport> findByAreaIdProvinceAndAreaNameCityAndStageIn(String districtCode, String cityName,
			String phaseName, Pageable pageable);

	Page<SchoolUploadResourceReport> findByAreaIdProvinceAndAreaNameDistrictAndStageIn(String districtCode,
			String areaName, String phaseName, Pageable pageable);

	Page<SchoolUploadResourceReport> findByAreaIdProvinceAndAreaNameDistrictAndSchoolNickLike(String districtCode,
			String areaName, String schoolName, Pageable pageable);

	Page<SchoolUploadResourceReport> findByAreaIdProvinceAndAreaNameDistrictOrderByResCountDesc(String districtCode,
			String areaName, Pageable pageable);

	Page<SchoolUploadResourceReport> findByAreaIdProvinceAndAreaNameDistrictOrderByResCountAsc(String districtCode,
			String areaName, Pageable pageable);

	Page<SchoolUploadResourceReport> findByAreaIdProvinceAndAreaNameDistrictOrderByShareResCountDesc(
			String districtCode, String areaName, Pageable pageable);

	Page<SchoolUploadResourceReport> findByAreaIdProvinceAndAreaNameDistrictOrderByShareResCountAsc(String districtCode,
			String areaName, Pageable pageable);

	Page<SchoolUploadResourceReport> findByAreaIdProvinceAndStageInAndSchoolNickLike(String districtCode,
			String phaseName, String schoolName, Pageable pageable);

	Page<SchoolUploadResourceReport> findByAreaIdProvinceAndStageInOrderByResCountDesc(String districtCode,
			String phaseName, Pageable pageable);

	Page<SchoolUploadResourceReport> findByAreaIdProvinceAndStageInOrderByResCountAsc(String districtCode,
			String phaseName, Pageable pageable);

	Page<SchoolUploadResourceReport> findByAreaIdProvinceAndStageInOrderByShareResCountDesc(String districtCode,
			String phaseName, Pageable pageable);

	Page<SchoolUploadResourceReport> findByAreaIdProvinceAndStageInOrderByShareResCountAsc(String districtCode,
			String phaseName, Pageable pageable);


	Page<SchoolUploadResourceReport> findByAreaIdProvinceAndAreaNameDistrictAndStageInAndSchoolNickLike(
			String districtCode, String areaName, String phaseName, String schoolName, Pageable pageable);

	Page<SchoolUploadResourceReport> findByAreaIdProvinceAndAreaNameDistrictAndStageInOrderByResCountDesc(
			String districtCode, String areaName, String phaseName, Pageable pageable);

	Page<SchoolUploadResourceReport> findByAreaIdProvinceAndAreaNameDistrictAndStageInOrderByResCountAsc(
			String districtCode, String areaName, String phaseName, Pageable pageable);

	Page<SchoolUploadResourceReport> findByAreaIdProvinceAndAreaNameDistrictAndStageInOrderByShareResCountDesc(
			String districtCode, String areaName, String phaseName, Pageable pageable);

	Page<SchoolUploadResourceReport> findByAreaIdProvinceAndAreaNameDistrictAndStageInOrderByShareResCountAsc(
			String districtCode, String areaName, String phaseName, Pageable pageable);

	Page<SchoolUploadResourceReport> findByAreaIdProvinceAndStageInAndSchoolNickLikeOrderByResCountDesc(
			String districtCode, String phaseName, String schoolName, Pageable pageable);

	Page<SchoolUploadResourceReport> findByAreaIdProvinceAndStageInAndSchoolNickLikeOrderByResCountAsc(
			String districtCode, String phaseName, String schoolName, Pageable pageable);

	Page<SchoolUploadResourceReport> findByAreaIdProvinceAndStageInAndSchoolNickLikeOrderByShareResCountDesc(
			String districtCode, String phaseName, String schoolName, Pageable pageable);

	Page<SchoolUploadResourceReport> findByAreaIdProvinceAndStageInAndSchoolNickLikeOrderByShareResCountAsc(
			String districtCode, String phaseName, String schoolName, Pageable pageable);

	Page<SchoolUploadResourceReport> findByAreaIdProvinceAndAreaNameDistrictAndSchoolNickLikeOrderByResCountDesc(
			String districtCode, String areaName, String schoolName, Pageable pageable);

	Page<SchoolUploadResourceReport> findByAreaIdProvinceAndAreaNameDistrictAndSchoolNickLikeOrderByResCountAsc(
			String districtCode, String areaName, String schoolName, Pageable pageable);

	Page<SchoolUploadResourceReport> findByAreaIdProvinceAndAreaNameDistrictAndSchoolNickLikeOrderByShareResCountDesc(
			String districtCode, String areaName, String schoolName, Pageable pageable);

	Page<SchoolUploadResourceReport> findByAreaIdProvinceAndAreaNameDistrictAndSchoolNickLikeOrderByShareResCountAsc(
			String districtCode, String areaName, String schoolName, Pageable pageable);

	Page<SchoolUploadResourceReport> findByAreaIdProvinceAndAreaNameCityAndStageInOrderByResCountDesc(
			String districtCode, String cityName, String phaseName, Pageable pageable);

	Page<SchoolUploadResourceReport> findByAreaIdProvinceAndAreaNameCityAndStageInOrderByResCountAsc(
			String districtCode, String cityName, String phaseName, Pageable pageable);

	Page<SchoolUploadResourceReport> findByAreaIdProvinceAndAreaNameCityAndStageInOrderByShareResCountDesc(
			String districtCode, String cityName, String phaseName, Pageable pageable);

	Page<SchoolUploadResourceReport> findByAreaIdProvinceAndAreaNameCityAndStageInOrderByShareResCountAsc(
			String districtCode, String cityName, String phaseName, Pageable pageable);

	Page<SchoolUploadResourceReport> findByAreaIdProvinceAndAreaNameDistrictAndStageInAndSchoolNickLikeOrderByResCountDesc(
			String districtCode, String areaName, String phaseName, String schoolName, Pageable pageable);

	Page<SchoolUploadResourceReport> findByAreaIdProvinceAndAreaNameDistrictAndStageInAndSchoolNickLikeOrderByResCountAsc(
			String districtCode, String areaName, String phaseName, String schoolName, Pageable pageable);

	Page<SchoolUploadResourceReport> findByAreaIdProvinceAndAreaNameDistrictAndStageInAndSchoolNickLikeOrderByShareResCountDesc(
			String districtCode, String areaName, String phaseName, String schoolName, Pageable pageable);

	Page<SchoolUploadResourceReport> findByAreaIdProvinceAndAreaNameDistrictAndStageInAndSchoolNickLikeOrderByShareResCountAsc(
			String districtCode, String areaName, String phaseName, String schoolName, Pageable pageable);

	Page<SchoolUploadResourceReport> findByAreaIdProvinceAndAreaNameCityAndStageInAndSchoolNickLike(String districtCode,
			String cityName, String phaseName, String schoolName, Pageable pageable);

	Page<SchoolUploadResourceReport> findByAreaIdProvinceAndAreaNameCityAndStageInAndSchoolNickLikeOrderByResCountDesc(
			String districtCode, String cityName, String phaseName, String schoolName, Pageable pageable);

	Page<SchoolUploadResourceReport> findByAreaIdProvinceAndAreaNameCityAndStageInAndSchoolNickLikeOrderByResCountAsc(
			String districtCode, String cityName, String phaseName, String schoolName, Pageable pageable);

	Page<SchoolUploadResourceReport> findByAreaIdProvinceAndAreaNameCityAndStageInAndSchoolNickLikeOrderByShareResCountDesc(
			String districtCode, String cityName, String phaseName, String schoolName, Pageable pageable);

	Page<SchoolUploadResourceReport> findByAreaIdProvinceAndAreaNameCityAndStageInAndSchoolNickLikeOrderByShareResCountAsc(
			String districtCode, String cityName, String phaseName, String schoolName, Pageable pageable);

	SchoolUploadResourceReport findBySchoolId(String key);


}
